[dbo].[BAEOrderProductGetAllChildren]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEOrderProductGetAllChildren

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@OrderProductID	int	4

SQL Script

create procedure [dbo].[BAEOrderProductGetAllChildren] @OrderProductID as
int
AS
    SELECT OrderSuperProductChildProduct.*
    FROM OrderProduct JOIN OrderSuperProductChildProduct ON OrderSuperProductChildProduct.OrderProductID = OrderProduct.OrderProductID
    WHERE OrderProduct.OrderProductID = @OrderProductID
    ORDER BY OrderProduct.OrderProductID;

GO

Uses

[dbo].[OrderProduct]
[dbo].[OrderSuperProductChildProduct]
dbo